<?php

require_once '../mysqlConnect.php';

function retrieveNeuropsychologicalSymptomQuestions() {

	$conn = GetPDOConnection();
	$sql = "SELECT * FROM neuropsychological_symptom_questions WHERE text != 'Record Date' ORDER BY qnumber";
	$STH = $conn->prepare($sql);
	$STH->setFetchMode(PDO::FETCH_ASSOC);
	$STH->execute();
	$symptoms = $STH->fetchAll();
	
	foreach ($symptoms as $key => $symptomInfo)
		$symptoms[$key]['answer_options'] = getDropDownOptions($symptomInfo['type_options']);
		
	$conn = null;
	return $symptoms;
}